<?php
ob_start();
//echo $_REQUEST['country'];
	session_start();
	require("UserIncludes/DbConfig.php");
main();
ob_end_flush();
function main()
{
 $sql = "select * from state where country_code='".$_REQUEST['country']."' ";

$query = mysql_query($sql) or die(mysql_error());
$num=mysql_num_rows($query);
if($num>0)
{
?>
			 <select name="shipping_state" class="combo" >
                <option value="">--Select--</option>
				<?
				while($rec=mysql_fetch_array($query))
				{
				?>
                <option value="<?php echo $rec['stateId']?>"><?php echo $rec['state_name']?></option>
                <?
				}
				?>
				              </select>
<?php
}
else
{
?>
 <select name="shipping_state" class="combo" disabled="true">
                <option value="">--Select--</option>
				              </select>
<?
}
}
?>

